Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	47935
Missing cells	288011
Missing cells (%)	37.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.9 MiB
Average record size in memory	128.0 B

Variable types

Categorical	6
Numeric	9
Unsupported	1

Alerts

`Unnamed: 10` has constant value "#NAME?"	Constant
`Unnamed: 11` has constant value "#NAME?"	Constant
`country` has a high cardinality: 204 distinct values	High cardinality
`pub_id` is highly overall correlated with `Unnamed: 13` and 1 other fields	High correlation
`app_id` is highly overall correlated with `Unnamed: 13` and 1 other fields	High correlation
`ad_unit_code` is highly overall correlated with `Unnamed: 15` and 2 other fields	High correlation
`requests` is highly overall correlated with `ae_responses` and 3 other fields	High correlation
`ae_responses` is highly overall correlated with `requests` and 4 other fields	High correlation
`ae_impressions` is highly overall correlated with `requests` and 5 other fields	High correlation
`ae_clicks` is highly overall correlated with `ae_impressions` and 3 other fields	High correlation
`ae_revenue` is highly overall correlated with `ae_responses` and 4 other fields	High correlation
`Unnamed: 15` is highly overall correlated with `ad_unit_code` and 3 other fields	High correlation
`date` is highly overall correlated with `Unnamed: 15` and 2 other fields	High correlation
`Unnamed: 13` is highly overall correlated with `pub_id` and 10 other fields	High correlation
`Unnamed: 14` is highly overall correlated with `pub_id` and 10 other fields	High correlation
`Unnamed: 10` has 47934 (> 99.9%) missing values	Missing
`Unnamed: 11` has 47934 (> 99.9%) missing values	Missing
`Unnamed: 12` has 47935 (100.0%) missing values	Missing
`Unnamed: 13` has 47929 (> 99.9%) missing values	Missing
`Unnamed: 14` has 47930 (> 99.9%) missing values	Missing
`Unnamed: 15` has 47929 (> 99.9%) missing values	Missing
`requests` is highly skewed (γ1 = 21.74933334)	Skewed
`ae_responses` is highly skewed (γ1 = 22.84978943)	Skewed
`ae_impressions` is highly skewed (γ1 = 21.14684899)	Skewed
`ae_clicks` is highly skewed (γ1 = 38.07757129)	Skewed
`ae_revenue` is highly skewed (γ1 = 42.19101501)	Skewed
`Unnamed: 13` is uniformly distributed	Uniform
`Unnamed: 14` is uniformly distributed	Uniform
`Unnamed: 12` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ae_clicks` has 14839 (31.0%) zeros	Zeros

Reproduction

Analysis started	2023-04-14 17:23:12.539128
Analysis finished	2023-04-14 17:23:35.296626
Duration	22.76 seconds
Software version	pandas-profiling vv3.6.3
Download configuration	config.json

date
Categorical

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	374.6 KiB

07-10-2022	1783
08-10-2022	1758
06-10-2022	1737
02-10-2022	1724
05-10-2022	1711
Other values (26)	39222

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	479350
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20-10-2022
2nd row	20-10-2022
3rd row	20-10-2022
4th row	20-10-2022
5th row	20-10-2022

Common Values

Value	Count	Frequency (%)
07-10-2022	1783	3.7%
08-10-2022	1758	3.7%
06-10-2022	1737	3.6%
02-10-2022	1724	3.6%
05-10-2022	1711	3.6%
04-10-2022	1686	3.5%
09-10-2022	1676	3.5%
03-10-2022	1667	3.5%
01-10-2022	1613	3.4%
19-10-2022	1570	3.3%
Other values (21)	31010	64.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
07-10-2022	1783	3.7%
08-10-2022	1758	3.7%
06-10-2022	1737	3.6%
02-10-2022	1724	3.6%
05-10-2022	1711	3.6%
04-10-2022	1686	3.5%
09-10-2022	1676	3.5%
03-10-2022	1667	3.5%
01-10-2022	1613	3.4%
19-10-2022	1570	3.3%
Other values (21)	31010	64.7%

Most occurring characters

Value	Count	Frequency (%)
2	163596	34.1%
0	115674	24.1%
-	95870	20.0%
1	68460	14.3%
3	7501	1.6%
9	4764	1.0%
8	4758	1.0%
5	4729	1.0%
7	4697	1.0%
4	4668	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	383480	80.0%
Dash Punctuation	95870	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	163596	42.7%
0	115674	30.2%
1	68460	17.9%
3	7501	2.0%
9	4764	1.2%
8	4758	1.2%
5	4729	1.2%
7	4697	1.2%
4	4668	1.2%
6	4633	1.2%

Dash Punctuation

Value	Count	Frequency (%)
-	95870	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	479350	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	163596	34.1%
0	115674	24.1%
-	95870	20.0%
1	68460	14.3%
3	7501	1.6%
9	4764	1.0%
8	4758	1.0%
5	4729	1.0%
7	4697	1.0%
4	4668	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	479350	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	163596	34.1%
0	115674	24.1%
-	95870	20.0%
1	68460	14.3%
3	7501	1.6%
9	4764	1.0%
8	4758	1.0%
5	4729	1.0%
7	4697	1.0%
4	4668	1.0%

pub_id
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	413.18821

Minimum	14
Maximum	2808
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	14
5-th percentile	14
Q1	14
median	51
Q3	72
95-th percentile	2808
Maximum	2808
Range	2794
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	893.64566
Coefficient of variation (CV)	2.1628053
Kurtosis	2.9881305
Mean	413.18821
Median Absolute Deviation (MAD)	37
Skewness	2.1893061
Sum	19806177
Variance	798602.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
14	17349	36.2%
51	14949	31.2%
2808	5442	11.4%
72	4906	10.2%
281	2317	4.8%
879	1605	3.3%
107	557	1.2%
1987	521	1.1%
34	289	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14	17349	36.2%
34	289	0.6%
51	14949	31.2%
72	4906	10.2%
107	557	1.2%
281	2317	4.8%
879	1605	3.3%
1987	521	1.1%
2808	5442	11.4%

Value	Count	Frequency (%)
2808	5442	11.4%
1987	521	1.1%
879	1605	3.3%
281	2317	4.8%
107	557	1.2%
72	4906	10.2%
51	14949	31.2%
34	289	0.6%
14	17349	36.2%

app_id
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50155772

Minimum	16243270
Maximum	95674771
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	16243270
5-th percentile	22693095
Q1	25596802
median	47862278
Q3	47862278
95-th percentile	95674771
Maximum	95674771
Range	79431501
Interquartile range (IQR)	22265476

Descriptive statistics

Standard deviation	24657717
Coefficient of variation (CV)	0.49162273
Kurtosis	-0.70216238
Mean	50155772
Median Absolute Deviation (MAD)	22265476
Skewness	0.68752648
Sum	2.4042169 × 10¹²
Variance	6.0800303 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
47862278	14949	31.2%
22693095	11291	23.6%
95674771	6058	12.6%
43840611	5442	11.4%
84650721	4906	10.2%
40931528	2317	4.8%
25596802	1605	3.3%
63338696	557	1.2%
16243270	521	1.1%
66981243	289	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16243270	521	1.1%
22693095	11291	23.6%
25596802	1605	3.3%
40931528	2317	4.8%
43840611	5442	11.4%
47862278	14949	31.2%
63338696	557	1.2%
66981243	289	0.6%
84650721	4906	10.2%
95674771	6058	12.6%

Value	Count	Frequency (%)
95674771	6058	12.6%
84650721	4906	10.2%
66981243	289	0.6%
63338696	557	1.2%
47862278	14949	31.2%
43840611	5442	11.4%
40931528	2317	4.8%
25596802	1605	3.3%
22693095	11291	23.6%
16243270	521	1.1%

ad_unit_code
Real number (ℝ)

Distinct	56
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2684021 × 10¹⁰

Minimum	2.2477474 × 10¹⁰
Maximum	2.283576 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	2.2477474 × 10¹⁰
5-th percentile	2.2477733 × 10¹⁰
Q1	2.2521511 × 10¹⁰
median	2.275208 × 10¹⁰
Q3	2.2770341 × 10¹⁰
95-th percentile	2.2827807 × 10¹⁰
Maximum	2.283576 × 10¹⁰
Range	3.5828642 × 10⁸
Interquartile range (IQR)	2.488309 × 10⁸

Descriptive statistics

Standard deviation	1.215869 × 10⁸
Coefficient of variation (CV)	0.0053600243
Kurtosis	-1.1893423
Mean	2.2684021 × 10¹⁰
Median Absolute Deviation (MAD)	54282040
Skewness	-0.6484422
Sum	1.0873585 × 10¹⁵
Variance	1.4783375 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.275263244 × 10¹⁰	4808	10.0%
2.275208048 × 10¹⁰	4617	9.6%
2.277034143 × 10¹⁰	2553	5.3%
2.269779844 × 10¹⁰	2485	5.2%
2.275208067 × 10¹⁰	1866	3.9%
2.278852573 × 10¹⁰	1801	3.8%
2.277034105 × 10¹⁰	1745	3.6%
2.252151044 × 10¹⁰	1692	3.5%
2.27703416 × 10¹⁰	1647	3.4%
2.252150936 × 10¹⁰	1614	3.4%
Other values (46)	23107	48.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.24774737 × 10¹⁰	1525	3.2%
2.247773309 × 10¹⁰	994	2.1%
2.247773311 × 10¹⁰	815	1.7%
2.247773316 × 10¹⁰	107	0.2%
2.248763942 × 10¹⁰	1186	2.5%
2.248763971 × 10¹⁰	923	1.9%
2.248763972 × 10¹⁰	848	1.8%
2.252149148 × 10¹⁰	157	0.3%
2.252150936 × 10¹⁰	1614	3.4%
2.252151027 × 10¹⁰	1590	3.3%

Value	Count	Frequency (%)
2.283576012 × 10¹⁰	663	1.4%
2.283540832 × 10¹⁰	1182	2.5%
2.283284659 × 10¹⁰	206	0.4%
2.283284644 × 10¹⁰	226	0.5%
2.283282773 × 10¹⁰	89	0.2%
2.282780711 × 10¹⁰	555	1.2%
2.282780606 × 10¹⁰	624	1.3%
2.282747522 × 10¹⁰	590	1.2%
2.282747502 × 10¹⁰	548	1.1%
2.282064594 × 10¹⁰	96	0.2%

country
Categorical

Distinct	204
Distinct (%)	0.4%
Missing	420
Missing (%)	0.9%
Memory size	374.6 KiB

India	1230
United States	974
Brazil	911
Saudi Arabia	879
Nigeria	878
Other values (199)	42643

Length

Max length	32
Median length	22
Mean length	8.1724087
Min length	4

Characters and Unicode

Total characters	388312
Distinct characters	57
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	Tanzania
2nd row	Tanzania
3rd row	Thailand
4th row	Thailand
5th row	Thailand

Common Values

Value	Count	Frequency (%)
India	1230	2.6%
United States	974	2.0%
Brazil	911	1.9%
Saudi Arabia	879	1.8%
Nigeria	878	1.8%
France	812	1.7%
United Kingdom	811	1.7%
Pakistan	803	1.7%
South Africa	780	1.6%
Mexico	761	1.6%
Other values (194)	38676	80.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
united	2344	4.1%
india	1230	2.2%
south	1210	2.1%
states	974	1.7%
brazil	911	1.6%
saudi	879	1.5%
arabia	879	1.5%
nigeria	878	1.5%
france	812	1.4%
kingdom	811	1.4%
Other values (227)	46281	80.9%

Most occurring characters

Value	Count	Frequency (%)
a	60619	15.6%
i	35875	9.2%
n	29945	7.7%
e	28166	7.3%
r	21816	5.6%
o	17534	4.5%
t	16475	4.2%
d	14106	3.6%
l	13719	3.5%
u	11467	3.0%
Other values (47)	138590	35.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	320884	82.6%
Uppercase Letter	56556	14.6%
Space Separator	9694	2.5%
Other Punctuation	385	0.1%
Open Punctuation	341	0.1%
Close Punctuation	341	0.1%
Dash Punctuation	111	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	60619	18.9%
i	35875	11.2%
n	29945	9.3%
e	28166	8.8%
r	21816	6.8%
o	17534	5.5%
t	16475	5.1%
d	14106	4.4%
l	13719	4.3%
u	11467	3.6%
Other values (16)	71162	22.2%

Uppercase Letter

Value	Count	Frequency (%)
S	7183	12.7%
A	4992	8.8%
I	4211	7.4%
B	4100	7.2%
U	3681	6.5%
C	3650	6.5%
M	3442	6.1%
P	3224	5.7%
K	3070	5.4%
T	2853	5.0%
Other values (15)	16150	28.6%

Other Punctuation

Value	Count	Frequency (%)
'	383	99.5%
.	2	0.5%

Space Separator

Value	Count	Frequency (%)
	9694	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	341	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	341	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	111	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	377440	97.2%
Common	10872	2.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	60619	16.1%
i	35875	9.5%
n	29945	7.9%
e	28166	7.5%
r	21816	5.8%
o	17534	4.6%
t	16475	4.4%
d	14106	3.7%
l	13719	3.6%
u	11467	3.0%
Other values (41)	127718	33.8%

Common

Value	Count	Frequency (%)
	9694	89.2%
'	383	3.5%
(	341	3.1%
)	341	3.1%
-	111	1.0%
.	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	388312	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	60619	15.6%
i	35875	9.2%
n	29945	7.7%
e	28166	7.3%
r	21816	5.6%
o	17534	4.5%
t	16475	4.2%
d	14106	3.6%
l	13719	3.5%
u	11467	3.0%
Other values (47)	138590	35.7%

requests
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3783
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	585.82781

Minimum	16
Maximum	156435
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	16
5-th percentile	24
Q1	50
median	109
Q3	300
95-th percentile	1960
Maximum	156435
Range	156419
Interquartile range (IQR)	250

Descriptive statistics

Standard deviation	3024.6865
Coefficient of variation (CV)	5.1630982
Kurtosis	683.38141
Mean	585.82781
Median Absolute Deviation (MAD)	74
Skewness	21.749333
Sum	28081656
Variance	9148728.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	404	0.8%
28	404	0.8%
32	397	0.8%
30	389	0.8%
23	388	0.8%
35	383	0.8%
33	382	0.8%
25	382	0.8%
31	375	0.8%
41	374	0.8%
Other values (3773)	44057	91.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	158	0.3%
17	195	0.4%
18	277	0.6%
19	308	0.6%
20	340	0.7%
21	350	0.7%
22	370	0.8%
23	388	0.8%
24	350	0.7%
25	382	0.8%

Value	Count	Frequency (%)
156435	1	< 0.1%
128311	1	< 0.1%
120564	1	< 0.1%
120331	1	< 0.1%
115997	1	< 0.1%
109421	1	< 0.1%
107968	1	< 0.1%
103295	1	< 0.1%
97698	1	< 0.1%
96027	1	< 0.1%

ae_responses
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3636
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	516.9182

Minimum	16
Maximum	156296
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	16
5-th percentile	23
Q1	47
median	100
Q3	275
95-th percentile	1816
Maximum	156296
Range	156280
Interquartile range (IQR)	228

Descriptive statistics

Standard deviation	2579.6957
Coefficient of variation (CV)	4.9905299
Kurtosis	805.17104
Mean	516.9182
Median Absolute Deviation (MAD)	67
Skewness	22.849789
Sum	24778474
Variance	6654830
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	465	1.0%
31	434	0.9%
25	433	0.9%
32	431	0.9%
29	422	0.9%
27	420	0.9%
22	420	0.9%
23	416	0.9%
26	413	0.9%
40	408	0.9%
Other values (3626)	43673	91.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	177	0.4%
17	243	0.5%
18	326	0.7%
19	340	0.7%
20	390	0.8%
21	389	0.8%
22	420	0.9%
23	416	0.9%
24	377	0.8%
25	433	0.9%

Value	Count	Frequency (%)
156296	1	< 0.1%
126743	1	< 0.1%
109177	1	< 0.1%
97635	1	< 0.1%
87806	1	< 0.1%
85822	1	< 0.1%
82148	1	< 0.1%
79930	1	< 0.1%
78464	1	< 0.1%
77374	1	< 0.1%

ae_impressions
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2448
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	257.05514

Minimum	16
Maximum	69448
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	16
5-th percentile	17
Q1	27
median	52
Q3	140
95-th percentile	839
Maximum	69448
Range	69432
Interquartile range (IQR)	113

Descriptive statistics

Standard deviation	1294.3136
Coefficient of variation (CV)	5.0351593
Kurtosis	637.41982
Mean	257.05514
Median Absolute Deviation (MAD)	31
Skewness	21.146849
Sum	12321938
Variance	1675247.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	1396	2.9%
17	1363	2.8%
18	1227	2.6%
19	1206	2.5%
20	1079	2.3%
21	1013	2.1%
22	932	1.9%
23	928	1.9%
24	867	1.8%
25	803	1.7%
Other values (2438)	37121	77.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	1396	2.9%
17	1363	2.8%
18	1227	2.6%
19	1206	2.5%
20	1079	2.3%
21	1013	2.1%
22	932	1.9%
23	928	1.9%
24	867	1.8%
25	803	1.7%

Value	Count	Frequency (%)
69448	1	< 0.1%
57126	1	< 0.1%
48011	1	< 0.1%
44503	1	< 0.1%
41852	1	< 0.1%
41785	1	< 0.1%
39941	1	< 0.1%
38639	1	< 0.1%
38097	1	< 0.1%
37877	1	< 0.1%

ae_clicks
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	481
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.502514

Minimum	0
Maximum	6853
Zeros	14839
Zeros (%)	31.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	7
95-th percentile	54
Maximum	6853
Range	6853
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	73.922916
Coefficient of variation (CV)	5.4747521
Kurtosis	2442.3768
Mean	13.502514
Median Absolute Deviation (MAD)	2
Skewness	38.077571
Sum	647243
Variance	5464.5975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14839	31.0%
1	6651	13.9%
2	4371	9.1%
3	3168	6.6%
4	2428	5.1%
5	1832	3.8%
6	1540	3.2%
7	1292	2.7%
8	1043	2.2%
9	853	1.8%
Other values (471)	9918	20.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14839	31.0%
1	6651	13.9%
2	4371	9.1%
3	3168	6.6%
4	2428	5.1%
5	1832	3.8%
6	1540	3.2%
7	1292	2.7%
8	1043	2.2%
9	853	1.8%

Value	Count	Frequency (%)
6853	1	< 0.1%
4415	1	< 0.1%
4227	1	< 0.1%
3537	1	< 0.1%
3310	1	< 0.1%
2872	1	< 0.1%
2851	1	< 0.1%
2748	1	< 0.1%
2291	1	< 0.1%
2247	1	< 0.1%

ae_revenue
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	43914
Distinct (%)	91.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0983199

Minimum	0.000111
Maximum	2137.1819
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	0.000111
5-th percentile	0.0036861
Q1	0.0260465
median	0.112968
Q3	0.537878
95-th percentile	4.7054774
Maximum	2137.1819
Range	2137.1818
Interquartile range (IQR)	0.5118315

Descriptive statistics

Standard deviation	27.784254
Coefficient of variation (CV)	13.24119
Kurtosis	2246.4576
Mean	2.0983199
Median Absolute Deviation (MAD)	0.104059
Skewness	42.191015
Sum	100582.97
Variance	771.96476
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.006658	6	< 0.1%
0.002566	6	< 0.1%
0.002842	6	< 0.1%
0.00445	5	< 0.1%
0.002506	5	< 0.1%
0.006756	5	< 0.1%
0.005598	5	< 0.1%
0.003386	5	< 0.1%
0.003614	5	< 0.1%
0.002626	5	< 0.1%
Other values (43904)	47882	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.000111	1	< 0.1%
0.000122	1	< 0.1%
0.000134	1	< 0.1%
0.000143	1	< 0.1%
0.000154	1	< 0.1%
0.000159	1	< 0.1%
0.000162	1	< 0.1%
0.000167	1	< 0.1%
0.000169	1	< 0.1%
0.000177	1	< 0.1%

Value	Count	Frequency (%)
2137.181915	1	< 0.1%
1860.866497	1	< 0.1%
1641.986936	1	< 0.1%
1457.692016	1	< 0.1%
1358.036254	1	< 0.1%
1327.266005	1	< 0.1%
1296.540283	1	< 0.1%
1241.249077	1	< 0.1%
954.945284	1	< 0.1%
925.251211	1	< 0.1%

Unnamed: 10
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	47934
Missing (%)	> 99.9%
Memory size	374.6 KiB

#NAME?	1

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	6
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	#NAME?

Common Values

Value	Count	Frequency (%)
#NAME?	1	< 0.1%
(Missing)	47934	> 99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
name	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
#	1	16.7%
N	1	16.7%
A	1	16.7%
M	1	16.7%
E	1	16.7%
?	1	16.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4	66.7%
Other Punctuation	2	33.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	1	25.0%
A	1	25.0%
M	1	25.0%
E	1	25.0%

Other Punctuation

Value	Count	Frequency (%)
#	1	50.0%
?	1	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4	66.7%
Common	2	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	1	25.0%
A	1	25.0%
M	1	25.0%
E	1	25.0%

Common

Value	Count	Frequency (%)
#	1	50.0%
?	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
#	1	16.7%
N	1	16.7%
A	1	16.7%
M	1	16.7%
E	1	16.7%
?	1	16.7%

Unnamed: 11
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	47934
Missing (%)	> 99.9%
Memory size	374.6 KiB

#NAME?	1

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	6
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	#NAME?

Common Values

Value	Count	Frequency (%)
#NAME?	1	< 0.1%
(Missing)	47934	> 99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
name	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
#	1	16.7%
N	1	16.7%
A	1	16.7%
M	1	16.7%
E	1	16.7%
?	1	16.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4	66.7%
Other Punctuation	2	33.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	1	25.0%
A	1	25.0%
M	1	25.0%
E	1	25.0%

Other Punctuation

Value	Count	Frequency (%)
#	1	50.0%
?	1	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4	66.7%
Common	2	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	1	25.0%
A	1	25.0%
M	1	25.0%
E	1	25.0%

Common

Value	Count	Frequency (%)
#	1	50.0%
?	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
#	1	16.7%
N	1	16.7%
A	1	16.7%
M	1	16.7%
E	1	16.7%
?	1	16.7%

Unnamed: 12
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	47935
Missing (%)	100.0%
Memory size	374.6 KiB

Unnamed: 13
Categorical

HIGH CORRELATION MISSING UNIFORM

Distinct	6
Distinct (%)	100.0%
Missing	47929
Missing (%)	> 99.9%
Memory size	374.6 KiB

b1	1
b2	1
b3	1
b4	1
b5	1

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	12
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	100.0%

Sample

1st row	b1
2nd row	b2
3rd row	b3
4th row	b4
5th row	b5

Common Values

Value	Count	Frequency (%)
b1	1	< 0.1%
b2	1	< 0.1%
b3	1	< 0.1%
b4	1	< 0.1%
b5	1	< 0.1%
b6	1	< 0.1%
(Missing)	47929	> 99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b1	1	16.7%
b2	1	16.7%
b3	1	16.7%
b4	1	16.7%
b5	1	16.7%
b6	1	16.7%

Most occurring characters

Value	Count	Frequency (%)
b	6	50.0%
1	1	8.3%
2	1	8.3%
3	1	8.3%
4	1	8.3%
5	1	8.3%
6	1	8.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6	50.0%
Decimal Number	6	50.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1	16.7%
2	1	16.7%
3	1	16.7%
4	1	16.7%
5	1	16.7%
6	1	16.7%

Lowercase Letter

Value	Count	Frequency (%)
b	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6	50.0%
Common	6	50.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1	16.7%
2	1	16.7%
3	1	16.7%
4	1	16.7%
5	1	16.7%
6	1	16.7%

Latin

Value	Count	Frequency (%)
b	6	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
b	6	50.0%
1	1	8.3%
2	1	8.3%
3	1	8.3%
4	1	8.3%
5	1	8.3%
6	1	8.3%

Unnamed: 14
Categorical

HIGH CORRELATION MISSING UNIFORM

Distinct	5
Distinct (%)	100.0%
Missing	47930
Missing (%)	> 99.9%
Memory size	374.6 KiB

1.0	1
100.0	1
300.0	1
600.0	1
1500.0	1

Length

Max length	6
Median length	5
Mean length	4.8
Min length	3

Characters and Unicode

Total characters	24
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	100.0%

Sample

1st row	1.0
2nd row	100.0
3rd row	300.0
4th row	600.0
5th row	1500.0

Common Values

Value	Count	Frequency (%)
1.0	1	< 0.1%
100.0	1	< 0.1%
300.0	1	< 0.1%
600.0	1	< 0.1%
1500.0	1	< 0.1%
(Missing)	47930	> 99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	1	20.0%
100.0	1	20.0%
300.0	1	20.0%
600.0	1	20.0%
1500.0	1	20.0%

Most occurring characters

Value	Count	Frequency (%)
0	13	54.2%
.	5	20.8%
1	3	12.5%
3	1	4.2%
6	1	4.2%
5	1	4.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	19	79.2%
Other Punctuation	5	20.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13	68.4%
1	3	15.8%
3	1	5.3%
6	1	5.3%
5	1	5.3%

Other Punctuation

Value	Count	Frequency (%)
.	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13	54.2%
.	5	20.8%
1	3	12.5%
3	1	4.2%
6	1	4.2%
5	1	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13	54.2%
.	5	20.8%
1	3	12.5%
3	1	4.2%
6	1	4.2%
5	1	4.2%

Unnamed: 15
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6
Distinct (%)	100.0%
Missing	47929
Missing (%)	> 99.9%
Infinite	0
Infinite (%)	0.0%
Mean	773

Minimum	0
Maximum	2138
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	374.6 KiB

Quantile statistics

Minimum	0
5-th percentile	25
Q1	150
median	450
Q3	1275
95-th percentile	1978.5
Maximum	2138
Range	2138
Interquartile range (IQR)	1125

Descriptive statistics

Standard deviation	859.75229
Coefficient of variation (CV)	1.1122281
Kurtosis	-0.6588904
Mean	773
Median Absolute Deviation (MAD)	400
Skewness	0.96765175
Sum	4638
Variance	739174
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	1	< 0.1%
100	1	< 0.1%
300	1	< 0.1%
600	1	< 0.1%
1500	1	< 0.1%
2138	1	< 0.1%
(Missing)	47929	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
100	1	< 0.1%
300	1	< 0.1%
600	1	< 0.1%
1500	1	< 0.1%
2138	1	< 0.1%

Value	Count	Frequency (%)
2138	1	< 0.1%
1500	1	< 0.1%
600	1	< 0.1%
300	1	< 0.1%
100	1	< 0.1%
0	1	< 0.1%

Auto

Heatmap
Table

	pub_id	app_id	ad_unit_code	requests	ae_responses	ae_impressions	ae_clicks	ae_revenue	Unnamed: 15	date	Unnamed: 13	Unnamed: 14
pub_id	1.000	0.072	-0.389	-0.167	-0.157	-0.196	-0.308	-0.205	NaN	0.110	1.000	1.000
app_id	0.072	1.000	-0.087	-0.310	-0.299	-0.187	-0.226	-0.303	NaN	0.081	1.000	1.000
ad_unit_code	-0.389	-0.087	1.000	0.097	0.124	0.083	0.025	0.104	-0.717	0.087	1.000	1.000
requests	-0.167	-0.310	0.097	1.000	0.986	0.905	0.467	0.478	-0.086	0.000	1.000	1.000
ae_responses	-0.157	-0.299	0.124	0.986	1.000	0.919	0.484	0.506	-0.143	0.000	1.000	1.000
ae_impressions	-0.196	-0.187	0.083	0.905	0.919	1.000	0.525	0.566	-0.086	0.000	1.000	1.000
ae_clicks	-0.308	-0.226	0.025	0.467	0.484	0.525	1.000	0.706	0.000	0.008	1.000	1.000
ae_revenue	-0.205	-0.303	0.104	0.478	0.506	0.566	0.706	1.000	-0.029	0.000	1.000	1.000
Unnamed: 15	NaN	NaN	-0.717	-0.086	-0.143	-0.086	0.000	-0.029	1.000	1.000	1.000	1.000
date	0.110	0.081	0.087	0.000	0.000	0.000	0.008	0.000	1.000	1.000	1.000	1.000
Unnamed: 13	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
Unnamed: 14	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	date	pub_id	app_id	ad_unit_code	country	requests	ae_responses	ae_impressions	ae_clicks	ae_revenue	Unnamed: 10	Unnamed: 11	Unnamed: 12	Unnamed: 13	Unnamed: 14	Unnamed: 15
0	20-10-2022	1987	16243270	22832846443	Tanzania	36	36	34	0	0.035738	#NAME?	NaN	NaN	NaN	NaN	NaN
1	20-10-2022	1987	16243270	22832846593	Tanzania	24	24	23	0	0.064384	NaN	#NAME?	NaN	b1	NaN	0.0
2	20-10-2022	1987	16243270	22832846443	Thailand	949	949	876	20	4.943878	NaN	NaN	NaN	b2	1.0	100.0
3	20-10-2022	1987	16243270	22832846593	Thailand	1006	907	688	134	24.226836	NaN	NaN	NaN	b3	100.0	300.0
4	20-10-2022	1987	16243270	22832827729	Thailand	373	287	156	20	2.759392	NaN	NaN	NaN	b4	300.0	600.0
5	20-10-2022	1987	16243270	22832846443	United States	225	225	212	2	4.316628	NaN	NaN	NaN	b5	600.0	1500.0
6	20-10-2022	1987	16243270	22832827729	United States	39	39	30	2	1.450446	NaN	NaN	NaN	b6	1500.0	2138.0
7	20-10-2022	1987	16243270	22832846593	United States	189	189	165	4	20.327859	NaN	NaN	NaN	NaN	NaN	NaN
8	20-10-2022	1987	16243270	22832846593	United Kingdom	33	33	25	1	1.874777	NaN	NaN	NaN	NaN	NaN	NaN
9	20-10-2022	1987	16243270	22832846443	United Kingdom	37	37	36	1	0.269845	NaN	NaN	NaN	NaN	NaN	NaN

	date	pub_id	app_id	ad_unit_code	country	requests	ae_responses	ae_impressions	ae_clicks	ae_revenue	Unnamed: 10	Unnamed: 11	Unnamed: 12	Unnamed: 13	Unnamed: 14	Unnamed: 15
47925	22-10-2022	14	95674771	22770341598	Venezuela	20	20	19	3	0.035682	NaN	NaN	NaN	NaN	NaN	NaN
47926	22-10-2022	14	95674771	22770341049	Albania	29	29	20	5	0.082596	NaN	NaN	NaN	NaN	NaN	NaN
47927	22-10-2022	14	95674771	22770341049	Peru	40	40	20	2	0.076515	NaN	NaN	NaN	NaN	NaN	NaN
47928	22-10-2022	14	95674771	22770341049	Philippines	40	36	20	4	0.112624	NaN	NaN	NaN	NaN	NaN	NaN
47929	22-10-2022	14	95674771	22770341049	Switzerland	37	37	20	3	1.466152	NaN	NaN	NaN	NaN	NaN	NaN
47930	22-10-2022	14	95674771	22770341049	El Salvador	34	34	21	4	0.022347	NaN	NaN	NaN	NaN	NaN	NaN
47931	22-10-2022	14	95674771	22770341430	Jordan	34	34	21	0	0.011894	NaN	NaN	NaN	NaN	NaN	NaN
47932	22-10-2022	14	95674771	22770341430	Somalia	46	46	21	2	0.003189	NaN	NaN	NaN	NaN	NaN	NaN
47933	22-10-2022	14	95674771	22770341598	Portugal	21	21	21	5	0.159408	NaN	NaN	NaN	NaN	NaN	NaN
47934	22-10-2022	14	95674771	22770341049	Thailand	40	40	21	1	0.140938	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values